// dao/userSqlMapping.js
// CRUD SQL语句
var user = {
	insert:'INSERT INTO loginuser(id, usercode, password, token) VALUES(0,?,?,1)',
	update:'update user set name=?, age=? where id=?',
	delete: 'delete from user where id=?',
	queryById: 'select * from user where id=?',
	queryAll: 'select * from user',
	findUser: 'select * from loginuser where usercode = ?',
	passwordecheck: 'select * from loginuser where usercode = ? && password = ?'
};
 
module.exports = user;